HI All,Hope some...
HI All,
Hope some one can help me here...
I have a requirement here where in when I am migrating the item instance iformation from legacy system to Oracle, I should check for the inventory item status and if its not 'Active', the status should be changed to active.
So wanted to know any possible ways to update the item status through pl/sql code.
Item status is determined by
Item status is determined by some item status attributes. So as per your organization check what are the attribute values to make the status active.
Populate this MTL_SYSTEM_ITEM_INTERFACE with correct attributes and then import the items